package com.nbgs.demo.dao;

import com.nbgs.demo.info.CountOverdueInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface CountOverdueMapper {


    @Select("select  bill_id,overdue,bill_generate_time from  t_waterbill where bill_state = '未缴'")
    List<CountOverdueInfo> selectOverdueInfo();

    @Update("update t_waterbill set overdue = #{overdue} where bill_id = #{billId}")
    void updateInfo(@Param("overdue") double overdue,@Param("billId") int billId);
}
